﻿CREATE TABLE [Enum].[Distinguished]
(
	[DistinguishedID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [CONSTANT_Enum_DistinguishedID] PRIMARY KEY,
	[Enum] NVARCHAR(100) NOT NULL CONSTRAINT [CONSTANT_Enum__Enum] UNIQUE, 
	[EnumDesc] NVARCHAR(500) NOT NULL,
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [CONSTANT_Enum_CreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [CONSTANT_Enum_DateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [CONSTANT_Enum_VersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [CONSTANT_Enum_VersionDate] DEFAULT GETDATE()
)
